package com.zhan.easyexcelorder.repository;

import com.zhan.easyexcelorder.model.SysRole;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

public interface SysRoleRepository extends PagingAndSortingRepository<SysRole, Long>, JpaSpecificationExecutor<SysRole> {
    @Query(value = "select s from SysRole s WHERE s.roleName = ?1")
    SysRole getSysRolesByRoleName(String rolename);
}
